SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 60010: PROC IMSTAT SET fails to append tables and returns an error that secondary tables must be partitioned by the same variables as the primary table

DetailsHotfixAboutRate It

A failure occurs when PROC IMSTAT SET is used to append tables that are partitioned on more than one variable.

An example is shown below.

26         /* partition on more than 1 column */
27         data lasrlib.carsmultipart (partition=(make model));
28         set sashelp.cars;
29         run;
NOTE: There were 428 observations read from the data set SASHELP.CARS.
NOTE: The data set LASRLIB.CARSMULTIPART has 428 observations and 15 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.00 seconds

30
31
32         proc imstat;
33         table lasrlib.carsmultipart;
34         partition make model;
35         run;
NOTE: The LASR Analytic Server action request for the PARTITION statement
completed in 0.018916 seconds.
36
37         table lasrlib.carsmultipart;
38         set &_templast_ / drop;
39         run;
ERROR: When appending tables to a partitioned LASR Analytic Server table the
secondary tables must be partitioned by the same variables as the primary table
or you must request that partitioning be removed from the primary table.
WARNING: The LASR Analytic Server action request for the SET statement did not
complete successfully.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS LASR Analytic ServerMicrosoft® Windows® for x642.72.79.4 TS1M39.4 TS1M4
Linux for x642.72.79.4 TS1M39.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.